mongodb extended json spec
README
이 문서는 MongoDB Manual에서 발췌한 것으로, BSON 포맷으로 저장될때, 또는 반대로 다양한 타입을 raw query로 작성하고 싶을때 참조할 수 있습니다.
| Example Field Name | Canonical Format | Relaxed Format |
|---|---|---|
| "_id": | {"$oid":"5d505646cf6d4fe581014ab2"} | {"$oid":"5d505646cf6d4fe581014ab2"} |
| "arrayField": | ["hello",{"$numberInt":"10"}] | ["hello",10] |
| "dateField": | {"$date":{"$numberLong":"1565546054692"}} | {"$date":"2019-08-11T17:54:14.692Z"} |
| "dateBefore1970": | {"$date":{"$numberLong":"-1577923200000"}} | {"$date":{"$numberLong":"-1577923200000"}} |
| "decimal128Field": | {"$numberDecimal":"10.99"} | {"$numberDecimal":"10.99"} |
| "documentField": | ||
| "doubleField": | {"$numberDouble":"10.5"} | 10.5 |
| "infiniteNumber" | {"$numberDouble":"Infinity"} | {"$numberDouble":"Infinity"} |
| "int32field": | {"$numberInt":"10"} | 10 |
| "int64Field": | {"$numberLong":"50"} | 50 |
| "minKeyField": | {"$minKey":1} | {"$minKey":1} |
| "maxKeyField": | {"$maxKey":1} | {"$maxKey":1} |
| "regexField": | {"$regularExpression":{"pattern":"^H","options":"i"}} | {"$regularExpression":{"pattern":"^H","options":"i"}} |
| "timestampField": | {"$timestamp":{"t":1565545664,"i":1}} | {"$timestamp":{"t":1565545664,"i":1}} |
| "uuid": | {"$uuid":"3b241101-e2bb-4255-8caf-4136c566a962"} | {"$uuid":"3b241101-e2bb-4255-8caf-4136c566a962"} |